﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="MyPhotoIndexDataSet" targetNamespace="http://tempuri.org/MyPhotoIndexDataSet.xsd" xmlns:mstns="http://tempuri.org/MyPhotoIndexDataSet.xsd" xmlns="http://tempuri.org/MyPhotoIndexDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="MyPhotoIndexConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="MyPhotoIndexConnectionString (Settings)" PropertyReference="ApplicationSettings.MyPhotoIndex.DataAccess.Properties.Settings.GlobalReference.Default.MyPhotoIndexConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ImageTagsTableAdapter" GeneratorDataComponentClassName="ImageTagsTableAdapter" Name="ImageTags" UserDataComponentName="ImageTagsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MyPhotoIndexConnectionString (Settings)" DbObjectName="ImageTags" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ImageTags` WHERE ((`Id` = ?) AND ((? = 1 AND `Parent` IS NULL) OR (`Parent` = ?)) AND ((? = 1 AND `offset` IS NULL) OR (`offset` = ?)) AND ((? = 1 AND `name` IS NULL) OR (`name` = ?)) AND ((? = 1 AND `description` IS NULL) OR (`description` = ?)) AND ((? = 1 AND `keyword` IS NULL) OR (`keyword` = ?)) AND ((? = 1 AND `ReferenceDate` IS NULL) OR (`ReferenceDate` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Parent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Parent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Parent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Parent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_offset" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="offset" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_offset" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="offset" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_description" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_keyword" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="keyword" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_keyword" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="keyword" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReferenceDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReferenceDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_ReferenceDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ReferenceDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ImageTags` (`Parent`, `offset`, `name`, `description`, `thumbnail`, `keyword`, `PhysicalFolder`, `ReferenceDate`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Parent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Parent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="offset" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="offset" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="thumbnail" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="thumbnail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="keyword" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="keyword" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PhysicalFolder" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="PhysicalFolder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ReferenceDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ReferenceDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Parent, offset, name, description, thumbnail, keyword, PhysicalFolder, ReferenceDate FROM ImageTags</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ImageTags` SET `Parent` = ?, `offset` = ?, `name` = ?, `description` = ?, `thumbnail` = ?, `keyword` = ?, `PhysicalFolder` = ?, `ReferenceDate` = ? WHERE ((`Id` = ?) AND ((? = 1 AND `Parent` IS NULL) OR (`Parent` = ?)) AND ((? = 1 AND `offset` IS NULL) OR (`offset` = ?)) AND ((? = 1 AND `name` IS NULL) OR (`name` = ?)) AND ((? = 1 AND `description` IS NULL) OR (`description` = ?)) AND ((? = 1 AND `keyword` IS NULL) OR (`keyword` = ?)) AND ((? = 1 AND `ReferenceDate` IS NULL) OR (`ReferenceDate` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Parent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Parent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="offset" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="offset" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="thumbnail" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="thumbnail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="keyword" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="keyword" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PhysicalFolder" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="PhysicalFolder" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="ReferenceDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ReferenceDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Parent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Parent" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Parent" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Parent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_offset" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="offset" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_offset" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="offset" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_description" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_keyword" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="keyword" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_keyword" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="keyword" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ReferenceDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReferenceDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_ReferenceDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ReferenceDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Parent" DataSetColumn="Parent" />
              <Mapping SourceColumn="offset" DataSetColumn="offset" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="thumbnail" DataSetColumn="thumbnail" />
              <Mapping SourceColumn="keyword" DataSetColumn="keyword" />
              <Mapping SourceColumn="PhysicalFolder" DataSetColumn="PhysicalFolder" />
              <Mapping SourceColumn="ReferenceDate" DataSetColumn="ReferenceDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ImagesTableAdapter" GeneratorDataComponentClassName="ImagesTableAdapter" Name="Images" UserDataComponentName="ImagesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MyPhotoIndexConnectionString (Settings)" DbObjectName="Images" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Images` WHERE ((`Id` = ?) AND ((? = 1 AND `ImportBatch` IS NULL) OR (`ImportBatch` = ?)) AND ((? = 1 AND `FullPath` IS NULL) OR (`FullPath` = ?)) AND ((? = 1 AND `FileCreationDate` IS NULL) OR (`FileCreationDate` = ?)) AND ((? = 1 AND `ImageDescription` IS NULL) OR (`ImageDescription` = ?)) AND ((? = 1 AND `CameraMaker` IS NULL) OR (`CameraMaker` = ?)) AND ((? = 1 AND `CameraModel` IS NULL) OR (`CameraModel` = ?)) AND ((? = 1 AND `XResolution` IS NULL) OR (`XResolution` = ?)) AND ((? = 1 AND `YResolution` IS NULL) OR (`YResolution` = ?)) AND ((? = 1 AND `ResolutionUnit` IS NULL) OR (`ResolutionUnit` = ?)) AND ((? = 1 AND `SoftwareUsed` IS NULL) OR (`SoftwareUsed` = ?)) AND ((? = 1 AND `LastModified` IS NULL) OR (`LastModified` = ?)) AND ((? = 1 AND `ExposureTime` IS NULL) OR (`ExposureTime` = ?)) AND ((? = 1 AND `Aperture` IS NULL) OR (`Aperture` = ?)) AND ((? = 1 AND `MaxAperture` IS NULL) OR (`MaxAperture` = ?)) AND ((? = 1 AND `ExposureProgram` IS NULL) OR (`ExposureProgram` = ?)) AND ((? = 1 AND `IsoSpeed` IS NULL) OR (`IsoSpeed` = ?)) AND ((? = 1 AND `DateTaken` IS NULL) OR (`DateTaken` = ?)) AND ((? = 1 AND `DateDigitized` IS NULL) OR (`DateDigitized` = ?)) AND ((? = 1 AND `BrightnessLevel` IS NULL) OR (`BrightnessLevel` = ?)) AND ((? = 1 AND `ExposureCompensation` IS NULL) OR (`ExposureCompensation` = ?)) AND ((? = 1 AND `MeteringMode` IS NULL) OR (`MeteringMode` = ?)) AND ((? = 1 AND `LightSource` IS NULL) OR (`LightSource` = ?)) AND ((? = 1 AND `FlashStatus` IS NULL) OR (`FlashStatus` = ?)) AND ((? = 1 AND `FocalLength` IS NULL) OR (`FocalLength` = ?)) AND ((? = 1 AND `Width` IS NULL) OR (`Width` = ?)) AND ((? = 1 AND `Height` IS NULL) OR (`Height` = ?)) AND ((? = 1 AND `Rating` IS NULL) OR (`Rating` = ?)) AND ((? = 1 AND `Categories` IS NULL) OR (`Categories` = ?)) AND ((? = 1 AND `ParentId` IS NULL) OR (`ParentId` = ?)) AND ((? = 1 AND `VersionDate` IS NULL) OR (`VersionDate` = ?)) AND ((? = 1 AND `SourceLabel` IS NULL) OR (`SourceLabel` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ImportBatch" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ImportBatch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ImportBatch" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ImportBatch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FullPath" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FullPath" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_FullPath" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FullPath" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FileCreationDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FileCreationDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_FileCreationDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FileCreationDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ImageDescription" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ImageDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ImageDescription" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ImageDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CameraMaker" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CameraMaker" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CameraMaker" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CameraMaker" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CameraModel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CameraModel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CameraModel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CameraModel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_XResolution" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="XResolution" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_XResolution" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="XResolution" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_YResolution" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="YResolution" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_YResolution" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="YResolution" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ResolutionUnit" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ResolutionUnit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_ResolutionUnit" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ResolutionUnit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SoftwareUsed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SoftwareUsed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_SoftwareUsed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SoftwareUsed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_LastModified" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="LastModified" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_LastModified" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastModified" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ExposureTime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ExposureTime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_ExposureTime" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ExposureTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Aperture" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Aperture" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Aperture" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Aperture" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_MaxAperture" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MaxAperture" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_MaxAperture" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="MaxAperture" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ExposureProgram" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ExposureProgram" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_ExposureProgram" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ExposureProgram" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsoSpeed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsoSpeed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IsoSpeed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsoSpeed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DateTaken" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DateTaken" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_DateTaken" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateTaken" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DateDigitized" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DateDigitized" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_DateDigitized" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateDigitized" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BrightnessLevel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BrightnessLevel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_BrightnessLevel" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="BrightnessLevel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ExposureCompensation" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ExposureCompensation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_ExposureCompensation" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="ExposureCompensation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_MeteringMode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MeteringMode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_MeteringMode" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="MeteringMode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_LightSource" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="LightSource" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_LightSource" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="LightSource" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FlashStatus" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FlashStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_FlashStatus" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="FlashStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FocalLength" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FocalLength" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_FocalLength" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="FocalLength" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Width" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Width" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Height" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Height" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Height" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Height" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Rating" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Rating" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Categories" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Categories" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Categories" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Categories" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ParentId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ParentId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VersionDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VersionDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_VersionDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="VersionDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SourceLabel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SourceLabel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_SourceLabel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SourceLabel" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Images` (`ImportBatch`, `FullPath`, `FileCreationDate`, `ImageDescription`, `CameraMaker`, `CameraModel`, `XResolution`, `YResolution`, `ResolutionUnit`, `SoftwareUsed`, `LastModified`, `ExposureTime`, `Aperture`, `MaxAperture`, `ExposureProgram`, `IsoSpeed`, `DateTaken`, `DateDigitized`, `BrightnessLevel`, `ExposureCompensation`, `MeteringMode`, `LightSource`, `FlashStatus`, `FocalLength`, `Width`, `Height`, `ImageTags`, `Rating`, `Categories`, `ParentId`, `VersionDate`, `SourceLabel`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ImportBatch" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ImportBatch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="FullPath" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FullPath" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="FileCreationDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FileCreationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ImageDescription" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ImageDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CameraMaker" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CameraMaker" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CameraModel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CameraModel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="XResolution" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="XResolution" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="YResolution" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="YResolution" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="ResolutionUnit" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ResolutionUnit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SoftwareUsed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SoftwareUsed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="LastModified" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastModified" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="ExposureTime" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ExposureTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Aperture" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Aperture" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="MaxAperture" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="MaxAperture" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="ExposureProgram" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ExposureProgram" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsoSpeed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsoSpeed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DateTaken" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateTaken" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DateDigitized" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateDigitized" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="BrightnessLevel" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="BrightnessLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="ExposureCompensation" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="ExposureCompensation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="MeteringMode" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="MeteringMode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="LightSource" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="LightSource" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="FlashStatus" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="FlashStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="FocalLength" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="FocalLength" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Width" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Height" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Height" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="ImageTags" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="ImageTags" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Rating" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Categories" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Categories" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ParentId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="VersionDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="VersionDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SourceLabel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SourceLabel" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, ImportBatch, FullPath, FileCreationDate, ImageDescription, CameraMaker, CameraModel, XResolution, YResolution, ResolutionUnit, SoftwareUsed, LastModified, ExposureTime, Aperture, MaxAperture, ExposureProgram, IsoSpeed, DateTaken, DateDigitized, BrightnessLevel, ExposureCompensation, MeteringMode, LightSource, FlashStatus, FocalLength, Width, Height, ImageTags, Rating, Categories, ParentId, VersionDate, SourceLabel FROM Images</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Images` SET `ImportBatch` = ?, `FullPath` = ?, `FileCreationDate` = ?, `ImageDescription` = ?, `CameraMaker` = ?, `CameraModel` = ?, `XResolution` = ?, `YResolution` = ?, `ResolutionUnit` = ?, `SoftwareUsed` = ?, `LastModified` = ?, `ExposureTime` = ?, `Aperture` = ?, `MaxAperture` = ?, `ExposureProgram` = ?, `IsoSpeed` = ?, `DateTaken` = ?, `DateDigitized` = ?, `BrightnessLevel` = ?, `ExposureCompensation` = ?, `MeteringMode` = ?, `LightSource` = ?, `FlashStatus` = ?, `FocalLength` = ?, `Width` = ?, `Height` = ?, `ImageTags` = ?, `Rating` = ?, `Categories` = ?, `ParentId` = ?, `VersionDate` = ?, `SourceLabel` = ? WHERE ((`Id` = ?) AND ((? = 1 AND `ImportBatch` IS NULL) OR (`ImportBatch` = ?)) AND ((? = 1 AND `FullPath` IS NULL) OR (`FullPath` = ?)) AND ((? = 1 AND `FileCreationDate` IS NULL) OR (`FileCreationDate` = ?)) AND ((? = 1 AND `ImageDescription` IS NULL) OR (`ImageDescription` = ?)) AND ((? = 1 AND `CameraMaker` IS NULL) OR (`CameraMaker` = ?)) AND ((? = 1 AND `CameraModel` IS NULL) OR (`CameraModel` = ?)) AND ((? = 1 AND `XResolution` IS NULL) OR (`XResolution` = ?)) AND ((? = 1 AND `YResolution` IS NULL) OR (`YResolution` = ?)) AND ((? = 1 AND `ResolutionUnit` IS NULL) OR (`ResolutionUnit` = ?)) AND ((? = 1 AND `SoftwareUsed` IS NULL) OR (`SoftwareUsed` = ?)) AND ((? = 1 AND `LastModified` IS NULL) OR (`LastModified` = ?)) AND ((? = 1 AND `ExposureTime` IS NULL) OR (`ExposureTime` = ?)) AND ((? = 1 AND `Aperture` IS NULL) OR (`Aperture` = ?)) AND ((? = 1 AND `MaxAperture` IS NULL) OR (`MaxAperture` = ?)) AND ((? = 1 AND `ExposureProgram` IS NULL) OR (`ExposureProgram` = ?)) AND ((? = 1 AND `IsoSpeed` IS NULL) OR (`IsoSpeed` = ?)) AND ((? = 1 AND `DateTaken` IS NULL) OR (`DateTaken` = ?)) AND ((? = 1 AND `DateDigitized` IS NULL) OR (`DateDigitized` = ?)) AND ((? = 1 AND `BrightnessLevel` IS NULL) OR (`BrightnessLevel` = ?)) AND ((? = 1 AND `ExposureCompensation` IS NULL) OR (`ExposureCompensation` = ?)) AND ((? = 1 AND `MeteringMode` IS NULL) OR (`MeteringMode` = ?)) AND ((? = 1 AND `LightSource` IS NULL) OR (`LightSource` = ?)) AND ((? = 1 AND `FlashStatus` IS NULL) OR (`FlashStatus` = ?)) AND ((? = 1 AND `FocalLength` IS NULL) OR (`FocalLength` = ?)) AND ((? = 1 AND `Width` IS NULL) OR (`Width` = ?)) AND ((? = 1 AND `Height` IS NULL) OR (`Height` = ?)) AND ((? = 1 AND `Rating` IS NULL) OR (`Rating` = ?)) AND ((? = 1 AND `Categories` IS NULL) OR (`Categories` = ?)) AND ((? = 1 AND `ParentId` IS NULL) OR (`ParentId` = ?)) AND ((? = 1 AND `VersionDate` IS NULL) OR (`VersionDate` = ?)) AND ((? = 1 AND `SourceLabel` IS NULL) OR (`SourceLabel` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ImportBatch" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ImportBatch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="FullPath" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FullPath" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="FileCreationDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FileCreationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ImageDescription" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ImageDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CameraMaker" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CameraMaker" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CameraModel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CameraModel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="XResolution" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="XResolution" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="YResolution" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="YResolution" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="ResolutionUnit" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ResolutionUnit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SoftwareUsed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SoftwareUsed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="LastModified" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastModified" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="ExposureTime" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ExposureTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Aperture" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Aperture" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="MaxAperture" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="MaxAperture" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="ExposureProgram" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ExposureProgram" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsoSpeed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsoSpeed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DateTaken" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateTaken" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DateDigitized" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateDigitized" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="BrightnessLevel" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="BrightnessLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="ExposureCompensation" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="ExposureCompensation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="MeteringMode" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="MeteringMode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="LightSource" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="LightSource" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="FlashStatus" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="FlashStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="FocalLength" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="FocalLength" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Width" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Height" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Height" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="ImageTags" Precision="0" ProviderType="LongVarBinary" Scale="0" Size="0" SourceColumn="ImageTags" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Rating" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Categories" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Categories" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ParentId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="VersionDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="VersionDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SourceLabel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SourceLabel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ImportBatch" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ImportBatch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ImportBatch" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ImportBatch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FullPath" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FullPath" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_FullPath" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FullPath" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FileCreationDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FileCreationDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_FileCreationDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="FileCreationDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ImageDescription" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ImageDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ImageDescription" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ImageDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CameraMaker" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CameraMaker" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CameraMaker" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CameraMaker" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CameraModel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CameraModel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CameraModel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CameraModel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_XResolution" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="XResolution" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_XResolution" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="XResolution" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_YResolution" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="YResolution" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_YResolution" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="YResolution" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ResolutionUnit" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ResolutionUnit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_ResolutionUnit" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ResolutionUnit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SoftwareUsed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SoftwareUsed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_SoftwareUsed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SoftwareUsed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_LastModified" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="LastModified" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_LastModified" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastModified" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ExposureTime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ExposureTime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_ExposureTime" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ExposureTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Aperture" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Aperture" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Aperture" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Aperture" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_MaxAperture" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MaxAperture" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_MaxAperture" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="MaxAperture" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ExposureProgram" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ExposureProgram" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_ExposureProgram" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ExposureProgram" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsoSpeed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsoSpeed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_IsoSpeed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsoSpeed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DateTaken" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DateTaken" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_DateTaken" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateTaken" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DateDigitized" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DateDigitized" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_DateDigitized" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DateDigitized" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_BrightnessLevel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="BrightnessLevel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_BrightnessLevel" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="BrightnessLevel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ExposureCompensation" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ExposureCompensation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_ExposureCompensation" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="ExposureCompensation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_MeteringMode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MeteringMode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_MeteringMode" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="MeteringMode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_LightSource" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="LightSource" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_LightSource" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="LightSource" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FlashStatus" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FlashStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_FlashStatus" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="FlashStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FocalLength" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FocalLength" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_FocalLength" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="FocalLength" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Width" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Width" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Height" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Height" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Height" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Height" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Rating" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Rating" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Categories" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Categories" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Categories" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Categories" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ParentId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ParentId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_VersionDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="VersionDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_VersionDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="VersionDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SourceLabel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SourceLabel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_SourceLabel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SourceLabel" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="ImportBatch" DataSetColumn="ImportBatch" />
              <Mapping SourceColumn="FullPath" DataSetColumn="FullPath" />
              <Mapping SourceColumn="FileCreationDate" DataSetColumn="FileCreationDate" />
              <Mapping SourceColumn="ImageDescription" DataSetColumn="ImageDescription" />
              <Mapping SourceColumn="CameraMaker" DataSetColumn="CameraMaker" />
              <Mapping SourceColumn="CameraModel" DataSetColumn="CameraModel" />
              <Mapping SourceColumn="XResolution" DataSetColumn="XResolution" />
              <Mapping SourceColumn="YResolution" DataSetColumn="YResolution" />
              <Mapping SourceColumn="ResolutionUnit" DataSetColumn="ResolutionUnit" />
              <Mapping SourceColumn="SoftwareUsed" DataSetColumn="SoftwareUsed" />
              <Mapping SourceColumn="LastModified" DataSetColumn="LastModified" />
              <Mapping SourceColumn="ExposureTime" DataSetColumn="ExposureTime" />
              <Mapping SourceColumn="Aperture" DataSetColumn="Aperture" />
              <Mapping SourceColumn="MaxAperture" DataSetColumn="MaxAperture" />
              <Mapping SourceColumn="ExposureProgram" DataSetColumn="ExposureProgram" />
              <Mapping SourceColumn="IsoSpeed" DataSetColumn="IsoSpeed" />
              <Mapping SourceColumn="DateTaken" DataSetColumn="DateTaken" />
              <Mapping SourceColumn="DateDigitized" DataSetColumn="DateDigitized" />
              <Mapping SourceColumn="BrightnessLevel" DataSetColumn="BrightnessLevel" />
              <Mapping SourceColumn="ExposureCompensation" DataSetColumn="ExposureCompensation" />
              <Mapping SourceColumn="MeteringMode" DataSetColumn="MeteringMode" />
              <Mapping SourceColumn="LightSource" DataSetColumn="LightSource" />
              <Mapping SourceColumn="FlashStatus" DataSetColumn="FlashStatus" />
              <Mapping SourceColumn="FocalLength" DataSetColumn="FocalLength" />
              <Mapping SourceColumn="Width" DataSetColumn="Width" />
              <Mapping SourceColumn="Height" DataSetColumn="Height" />
              <Mapping SourceColumn="ImageTags" DataSetColumn="ImageTags" />
              <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
              <Mapping SourceColumn="Categories" DataSetColumn="Categories" />
              <Mapping SourceColumn="ParentId" DataSetColumn="ParentId" />
              <Mapping SourceColumn="VersionDate" DataSetColumn="VersionDate" />
              <Mapping SourceColumn="SourceLabel" DataSetColumn="SourceLabel" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ImageCategoriesTableAdapter" GeneratorDataComponentClassName="ImageCategoriesTableAdapter" Name="ImageCategories" UserDataComponentName="ImageCategoriesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MyPhotoIndexConnectionString (Settings)" DbObjectName="ImageCategories" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ImageCategories` WHERE ((`Id` = ?) AND ((? = 1 AND `Description` IS NULL) OR (`Description` = ?)) AND ((? = 1 AND `Color` IS NULL) OR (`Color` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Description" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Color" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Color" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ImageCategories` (`Id`, `Description`, `Color`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Color" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, Description, Color FROM ImageCategories</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ImageCategories` SET `Id` = ?, `Description` = ?, `Color` = ? WHERE ((`Id` = ?) AND ((? = 1 AND `Description` IS NULL) OR (`Description` = ?)) AND ((? = 1 AND `Color` IS NULL) OR (`Color` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Color" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Description" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Color" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Color" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Color" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Color" DataSetColumn="Color" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SavedQueriesTableAdapter" GeneratorDataComponentClassName="SavedQueriesTableAdapter" Name="SavedQueries" UserDataComponentName="SavedQueriesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MyPhotoIndexConnectionString (Settings)" DbObjectName="SavedQueries" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `SavedQueries` WHERE ((`Id` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `SavedQueries` (`QueryData`) VALUES (?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="QueryData" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="QueryData" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Id, QueryData FROM SavedQueries</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `SavedQueries` SET `QueryData` = ? WHERE ((`Id` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="QueryData" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="QueryData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="QueryData" DataSetColumn="QueryData" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="MyPhotoIndexDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="MyPhotoIndexDataSet" msprop:Generator_DataSetName="MyPhotoIndexDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ImageTags" msprop:Generator_UserTableName="ImageTags" msprop:Generator_RowDeletedName="ImageTagsRowDeleted" msprop:Generator_RowChangedName="ImageTagsRowChanged" msprop:Generator_RowClassName="ImageTagsRow" msprop:Generator_RowChangingName="ImageTagsRowChanging" msprop:Generator_RowEvArgName="ImageTagsRowChangeEvent" msprop:Generator_RowEvHandlerName="ImageTagsRowChangeEventHandler" msprop:Generator_TableClassName="ImageTagsDataTable" msprop:Generator_TableVarName="tableImageTags" msprop:Generator_RowDeletingName="ImageTagsRowDeleting" msprop:Generator_TablePropName="ImageTags">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Parent" msprop:Generator_UserColumnName="Parent" msprop:Generator_ColumnVarNameInTable="columnParent" msprop:Generator_ColumnPropNameInRow="Parent" msprop:Generator_ColumnPropNameInTable="ParentColumn" type="xs:int" minOccurs="0" />
              <xs:element name="offset" msprop:Generator_UserColumnName="offset" msprop:Generator_ColumnVarNameInTable="columnoffset" msprop:Generator_ColumnPropNameInRow="offset" msprop:Generator_ColumnPropNameInTable="offsetColumn" type="xs:int" minOccurs="0" />
              <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="thumbnail" msprop:Generator_UserColumnName="thumbnail" msprop:Generator_ColumnVarNameInTable="columnthumbnail" msprop:Generator_ColumnPropNameInRow="thumbnail" msprop:Generator_ColumnPropNameInTable="thumbnailColumn" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="keyword" msprop:Generator_UserColumnName="keyword" msprop:Generator_ColumnVarNameInTable="columnkeyword" msprop:Generator_ColumnPropNameInRow="keyword" msprop:Generator_ColumnPropNameInTable="keywordColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PhysicalFolder" msprop:Generator_UserColumnName="PhysicalFolder" msprop:Generator_ColumnVarNameInTable="columnPhysicalFolder" msprop:Generator_ColumnPropNameInRow="PhysicalFolder" msprop:Generator_ColumnPropNameInTable="PhysicalFolderColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReferenceDate" msprop:Generator_UserColumnName="ReferenceDate" msprop:Generator_ColumnPropNameInRow="ReferenceDate" msprop:Generator_ColumnVarNameInTable="columnReferenceDate" msprop:Generator_ColumnPropNameInTable="ReferenceDateColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Images" msprop:Generator_UserTableName="Images" msprop:Generator_RowDeletedName="ImagesRowDeleted" msprop:Generator_RowChangedName="ImagesRowChanged" msprop:Generator_RowClassName="ImagesRow" msprop:Generator_RowChangingName="ImagesRowChanging" msprop:Generator_RowEvArgName="ImagesRowChangeEvent" msprop:Generator_RowEvHandlerName="ImagesRowChangeEventHandler" msprop:Generator_TableClassName="ImagesDataTable" msprop:Generator_TableVarName="tableImages" msprop:Generator_RowDeletingName="ImagesRowDeleting" msprop:Generator_TablePropName="Images">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="ImportBatch" msprop:Generator_UserColumnName="ImportBatch" msprop:Generator_ColumnVarNameInTable="columnImportBatch" msprop:Generator_ColumnPropNameInRow="ImportBatch" msprop:Generator_ColumnPropNameInTable="ImportBatchColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullPath" msprop:Generator_UserColumnName="FullPath" msprop:Generator_ColumnVarNameInTable="columnFullPath" msprop:Generator_ColumnPropNameInRow="FullPath" msprop:Generator_ColumnPropNameInTable="FullPathColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FileCreationDate" msprop:Generator_UserColumnName="FileCreationDate" msprop:Generator_ColumnVarNameInTable="columnFileCreationDate" msprop:Generator_ColumnPropNameInRow="FileCreationDate" msprop:Generator_ColumnPropNameInTable="FileCreationDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ImageDescription" msprop:Generator_UserColumnName="ImageDescription" msprop:Generator_ColumnVarNameInTable="columnImageDescription" msprop:Generator_ColumnPropNameInRow="ImageDescription" msprop:Generator_ColumnPropNameInTable="ImageDescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CameraMaker" msprop:Generator_UserColumnName="CameraMaker" msprop:Generator_ColumnVarNameInTable="columnCameraMaker" msprop:Generator_ColumnPropNameInRow="CameraMaker" msprop:Generator_ColumnPropNameInTable="CameraMakerColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CameraModel" msprop:Generator_UserColumnName="CameraModel" msprop:Generator_ColumnVarNameInTable="columnCameraModel" msprop:Generator_ColumnPropNameInRow="CameraModel" msprop:Generator_ColumnPropNameInTable="CameraModelColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="XResolution" msprop:Generator_UserColumnName="XResolution" msprop:Generator_ColumnVarNameInTable="columnXResolution" msprop:Generator_ColumnPropNameInRow="XResolution" msprop:Generator_ColumnPropNameInTable="XResolutionColumn" type="xs:short" minOccurs="0" />
              <xs:element name="YResolution" msprop:Generator_UserColumnName="YResolution" msprop:Generator_ColumnVarNameInTable="columnYResolution" msprop:Generator_ColumnPropNameInRow="YResolution" msprop:Generator_ColumnPropNameInTable="YResolutionColumn" type="xs:short" minOccurs="0" />
              <xs:element name="ResolutionUnit" msprop:Generator_UserColumnName="ResolutionUnit" msprop:Generator_ColumnVarNameInTable="columnResolutionUnit" msprop:Generator_ColumnPropNameInRow="ResolutionUnit" msprop:Generator_ColumnPropNameInTable="ResolutionUnitColumn" type="xs:short" minOccurs="0" />
              <xs:element name="SoftwareUsed" msprop:Generator_UserColumnName="SoftwareUsed" msprop:Generator_ColumnVarNameInTable="columnSoftwareUsed" msprop:Generator_ColumnPropNameInRow="SoftwareUsed" msprop:Generator_ColumnPropNameInTable="SoftwareUsedColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastModified" msprop:Generator_UserColumnName="LastModified" msprop:Generator_ColumnVarNameInTable="columnLastModified" msprop:Generator_ColumnPropNameInRow="LastModified" msprop:Generator_ColumnPropNameInTable="LastModifiedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ExposureTime" msprop:Generator_UserColumnName="ExposureTime" msprop:Generator_ColumnVarNameInTable="columnExposureTime" msprop:Generator_ColumnPropNameInRow="ExposureTime" msprop:Generator_ColumnPropNameInTable="ExposureTimeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Aperture" msprop:Generator_UserColumnName="Aperture" msprop:Generator_ColumnVarNameInTable="columnAperture" msprop:Generator_ColumnPropNameInRow="Aperture" msprop:Generator_ColumnPropNameInTable="ApertureColumn" type="xs:double" minOccurs="0" />
              <xs:element name="MaxAperture" msprop:Generator_UserColumnName="MaxAperture" msprop:Generator_ColumnVarNameInTable="columnMaxAperture" msprop:Generator_ColumnPropNameInRow="MaxAperture" msprop:Generator_ColumnPropNameInTable="MaxApertureColumn" type="xs:double" minOccurs="0" />
              <xs:element name="ExposureProgram" msprop:Generator_UserColumnName="ExposureProgram" msprop:Generator_ColumnVarNameInTable="columnExposureProgram" msprop:Generator_ColumnPropNameInRow="ExposureProgram" msprop:Generator_ColumnPropNameInTable="ExposureProgramColumn" type="xs:short" minOccurs="0" />
              <xs:element name="IsoSpeed" msprop:Generator_UserColumnName="IsoSpeed" msprop:Generator_ColumnVarNameInTable="columnIsoSpeed" msprop:Generator_ColumnPropNameInRow="IsoSpeed" msprop:Generator_ColumnPropNameInTable="IsoSpeedColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DateTaken" msprop:Generator_UserColumnName="DateTaken" msprop:Generator_ColumnVarNameInTable="columnDateTaken" msprop:Generator_ColumnPropNameInRow="DateTaken" msprop:Generator_ColumnPropNameInTable="DateTakenColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DateDigitized" msprop:Generator_UserColumnName="DateDigitized" msprop:Generator_ColumnVarNameInTable="columnDateDigitized" msprop:Generator_ColumnPropNameInRow="DateDigitized" msprop:Generator_ColumnPropNameInTable="DateDigitizedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="BrightnessLevel" msprop:Generator_UserColumnName="BrightnessLevel" msprop:Generator_ColumnVarNameInTable="columnBrightnessLevel" msprop:Generator_ColumnPropNameInRow="BrightnessLevel" msprop:Generator_ColumnPropNameInTable="BrightnessLevelColumn" type="xs:double" minOccurs="0" />
              <xs:element name="ExposureCompensation" msprop:Generator_UserColumnName="ExposureCompensation" msprop:Generator_ColumnVarNameInTable="columnExposureCompensation" msprop:Generator_ColumnPropNameInRow="ExposureCompensation" msprop:Generator_ColumnPropNameInTable="ExposureCompensationColumn" type="xs:float" minOccurs="0" />
              <xs:element name="MeteringMode" msprop:Generator_UserColumnName="MeteringMode" msprop:Generator_ColumnVarNameInTable="columnMeteringMode" msprop:Generator_ColumnPropNameInRow="MeteringMode" msprop:Generator_ColumnPropNameInTable="MeteringModeColumn" type="xs:short" minOccurs="0" />
              <xs:element name="LightSource" msprop:Generator_UserColumnName="LightSource" msprop:Generator_ColumnVarNameInTable="columnLightSource" msprop:Generator_ColumnPropNameInRow="LightSource" msprop:Generator_ColumnPropNameInTable="LightSourceColumn" type="xs:short" minOccurs="0" />
              <xs:element name="FlashStatus" msprop:Generator_UserColumnName="FlashStatus" msprop:Generator_ColumnVarNameInTable="columnFlashStatus" msprop:Generator_ColumnPropNameInRow="FlashStatus" msprop:Generator_ColumnPropNameInTable="FlashStatusColumn" type="xs:short" minOccurs="0" />
              <xs:element name="FocalLength" msprop:Generator_UserColumnName="FocalLength" msprop:Generator_ColumnVarNameInTable="columnFocalLength" msprop:Generator_ColumnPropNameInRow="FocalLength" msprop:Generator_ColumnPropNameInTable="FocalLengthColumn" type="xs:float" minOccurs="0" />
              <xs:element name="Width" msprop:Generator_UserColumnName="Width" msprop:Generator_ColumnVarNameInTable="columnWidth" msprop:Generator_ColumnPropNameInRow="Width" msprop:Generator_ColumnPropNameInTable="WidthColumn" type="xs:short" minOccurs="0" />
              <xs:element name="Height" msprop:Generator_UserColumnName="Height" msprop:Generator_ColumnVarNameInTable="columnHeight" msprop:Generator_ColumnPropNameInRow="Height" msprop:Generator_ColumnPropNameInTable="HeightColumn" type="xs:short" minOccurs="0" />
              <xs:element name="ImageTags" msprop:Generator_UserColumnName="ImageTags" msprop:Generator_ColumnVarNameInTable="columnImageTags" msprop:Generator_ColumnPropNameInRow="ImageTags" msprop:Generator_ColumnPropNameInTable="ImageTagsColumn" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="Rating" msprop:Generator_UserColumnName="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnPropNameInTable="RatingColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Categories" msprop:Generator_UserColumnName="Categories" msprop:Generator_ColumnVarNameInTable="columnCategories" msprop:Generator_ColumnPropNameInRow="Categories" msprop:Generator_ColumnPropNameInTable="CategoriesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ParentId" msprop:Generator_UserColumnName="ParentId" msprop:Generator_ColumnVarNameInTable="columnParentId" msprop:Generator_ColumnPropNameInRow="ParentId" msprop:Generator_ColumnPropNameInTable="ParentIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="VersionDate" msprop:Generator_UserColumnName="VersionDate" msprop:Generator_ColumnVarNameInTable="columnVersionDate" msprop:Generator_ColumnPropNameInRow="VersionDate" msprop:Generator_ColumnPropNameInTable="VersionDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="SourceLabel" msprop:Generator_UserColumnName="SourceLabel" msprop:Generator_ColumnPropNameInRow="SourceLabel" msprop:Generator_ColumnVarNameInTable="columnSourceLabel" msprop:Generator_ColumnPropNameInTable="SourceLabelColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ImageCategories" msprop:Generator_UserTableName="ImageCategories" msprop:Generator_RowDeletedName="ImageCategoriesRowDeleted" msprop:Generator_RowChangedName="ImageCategoriesRowChanged" msprop:Generator_RowClassName="ImageCategoriesRow" msprop:Generator_RowChangingName="ImageCategoriesRowChanging" msprop:Generator_RowEvArgName="ImageCategoriesRowChangeEvent" msprop:Generator_RowEvHandlerName="ImageCategoriesRowChangeEventHandler" msprop:Generator_TableClassName="ImageCategoriesDataTable" msprop:Generator_TableVarName="tableImageCategories" msprop:Generator_RowDeletingName="ImageCategoriesRowDeleting" msprop:Generator_TablePropName="ImageCategories">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Color" msprop:Generator_UserColumnName="Color" msprop:Generator_ColumnPropNameInRow="Color" msprop:Generator_ColumnVarNameInTable="columnColor" msprop:Generator_ColumnPropNameInTable="ColorColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SavedQueries" msprop:Generator_UserTableName="SavedQueries" msprop:Generator_RowDeletedName="SavedQueriesRowDeleted" msprop:Generator_RowChangedName="SavedQueriesRowChanged" msprop:Generator_RowClassName="SavedQueriesRow" msprop:Generator_RowChangingName="SavedQueriesRowChanging" msprop:Generator_RowEvArgName="SavedQueriesRowChangeEvent" msprop:Generator_RowEvHandlerName="SavedQueriesRowChangeEventHandler" msprop:Generator_TableClassName="SavedQueriesDataTable" msprop:Generator_TableVarName="tableSavedQueries" msprop:Generator_RowDeletingName="SavedQueriesRowDeleting" msprop:Generator_TablePropName="SavedQueries">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="QueryData" msprop:Generator_UserColumnName="QueryData" msprop:Generator_ColumnVarNameInTable="columnQueryData" msprop:Generator_ColumnPropNameInRow="QueryData" msprop:Generator_ColumnPropNameInTable="QueryDataColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ImageTags" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Images_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Images" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="ImageCategories_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ImageCategories" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="SavedQueries_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SavedQueries" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
  </xs:element>
</xs:schema>